Emotion Labeled Spotify Songs

Dataset statistics

Number of variables	15
Number of observations	277938
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	31.8 MiB
Average record size in memory	120.0 B

Variable types

Numeric	13
Categorical	1
Text	1

Alerts

`Unnamed: 0` is highly overall correlated with `Unnamed: 0.1`	High correlation
`Unnamed: 0.1` is highly overall correlated with `Unnamed: 0`	High correlation
`acousticness` is highly overall correlated with `energy` and 2 other fields	High correlation
`danceability` is highly overall correlated with `valence`	High correlation
`duration (ms)` is highly overall correlated with `spec_rate`	High correlation
`energy` is highly overall correlated with `acousticness` and 2 other fields	High correlation
`labels` is highly overall correlated with `acousticness` and 1 other fields	High correlation
`loudness` is highly overall correlated with `acousticness` and 1 other fields	High correlation
`spec_rate` is highly overall correlated with `duration (ms)` and 1 other fields	High correlation
`speechiness` is highly overall correlated with `spec_rate`	High correlation
`valence` is highly overall correlated with `danceability`	High correlation
`Unnamed: 0.1` is uniformly distributed	Uniform
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0.1` has unique values	Unique
`Unnamed: 0` has unique values	Unique
`uri` has unique values	Unique
`instrumentalness` has 71748 (25.8%) zeros	Zeros

Reproduction

Analysis started	2024-01-20 00:37:28.730475
Analysis finished	2024-01-20 00:39:02.801897
Duration	1 minute and 34.07 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

Unnamed: 0.1
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	277938
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	138968.5

Minimum	0
Maximum	277937
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	13896.85
Q1	69484.25
median	138968.5
Q3	208452.75
95-th percentile	264040.15
Maximum	277937
Range	277937
Interquartile range (IQR)	138968.5

Descriptive statistics

Standard deviation	80233.934
Coefficient of variation (CV)	0.57735339
Kurtosis	-1.2
Mean	138968.5
Median Absolute Deviation (MAD)	69484.5
Skewness	9.9864353 × 10^-16
Sum	3.8624627 × 10¹⁰
Variance	6.4374841 × 10⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
185297	1	< 0.1%
185283	1	< 0.1%
185284	1	< 0.1%
185285	1	< 0.1%
185286	1	< 0.1%
185287	1	< 0.1%
185288	1	< 0.1%
185289	1	< 0.1%
185290	1	< 0.1%
Other values (277928)	277928	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
277937	1	< 0.1%
277936	1	< 0.1%
277935	1	< 0.1%
277934	1	< 0.1%
277933	1	< 0.1%
277932	1	< 0.1%
277931	1	< 0.1%
277930	1	< 0.1%
277929	1	< 0.1%
277928	1	< 0.1%

Unnamed: 0
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	277938
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	138968.5

Minimum	0
Maximum	277937
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	13896.85
Q1	69484.25
median	138968.5
Q3	208452.75
95-th percentile	264040.15
Maximum	277937
Range	277937
Interquartile range (IQR)	138968.5

Descriptive statistics

Standard deviation	80233.934
Coefficient of variation (CV)	0.57735339
Kurtosis	-1.2
Mean	138968.5
Median Absolute Deviation (MAD)	69484.5
Skewness	9.9864353 × 10^-16
Sum	3.8624627 × 10¹⁰
Variance	6.4374841 × 10⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
185297	1	< 0.1%
185283	1	< 0.1%
185284	1	< 0.1%
185285	1	< 0.1%
185286	1	< 0.1%
185287	1	< 0.1%
185288	1	< 0.1%
185289	1	< 0.1%
185290	1	< 0.1%
Other values (277928)	277928	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
277937	1	< 0.1%
277936	1	< 0.1%
277935	1	< 0.1%
277934	1	< 0.1%
277933	1	< 0.1%
277932	1	< 0.1%
277931	1	< 0.1%
277930	1	< 0.1%
277929	1	< 0.1%
277928	1	< 0.1%

duration (ms)
Real number (ℝ)

HIGH CORRELATION

Distinct	114072
Distinct (%)	41.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	232496.08

Minimum	6706
Maximum	3919895
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	6706
5-th percentile	112785.55
Q1	172013
median	213105.5
Q3	264866
95-th percentile	411494.9
Maximum	3919895
Range	3913189
Interquartile range (IQR)	92853

Descriptive statistics

Standard deviation	117183.02
Coefficient of variation (CV)	0.50402148
Kurtosis	97.197787
Mean	232496.08
Median Absolute Deviation (MAD)	45477
Skewness	6.0626665
Sum	6.4619496 × 10¹⁰
Variance	1.373186 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
192000	264	0.1%
240000	227	0.1%
180000	221	0.1%
144000	162	0.1%
120000	161	0.1%
160000	158	0.1%
210000	150	0.1%
200000	149	0.1%
216000	147	0.1%
208000	146	0.1%
Other values (114062)	276153	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6706	1	< 0.1%
7145	1	< 0.1%
7229	1	< 0.1%
7891	1	< 0.1%
8747	1	< 0.1%
8973	1	< 0.1%
9493	1	< 0.1%
9600	1	< 0.1%
11227	1	< 0.1%
11773	1	< 0.1%

Value	Count	Frequency (%)
3919895	1	< 0.1%
3697969	1	< 0.1%
3653565	1	< 0.1%
3650064	1	< 0.1%
3634235	1	< 0.1%
3604214	1	< 0.1%
3603000	1	< 0.1%
3600000	4	< 0.1%
3473453	1	< 0.1%
3432107	1	< 0.1%

danceability
Real number (ℝ)

HIGH CORRELATION

Distinct	1327
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.55258339

Minimum	0
Maximum	0.989
Zeros	90
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.196
Q1	0.431
median	0.571
Q3	0.693
95-th percentile	0.833
Maximum	0.989
Range	0.989
Interquartile range (IQR)	0.262

Descriptive statistics

Standard deviation	0.18890482
Coefficient of variation (CV)	0.34185758
Kurtosis	-0.39338197
Mean	0.55258339
Median Absolute Deviation (MAD)	0.13
Skewness	-0.38570711
Sum	153583.92
Variance	0.035685032
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.565	636	0.2%
0.608	633	0.2%
0.633	624	0.2%
0.583	624	0.2%
0.594	618	0.2%
0.599	618	0.2%
0.588	617	0.2%
0.629	615	0.2%
0.552	612	0.2%
0.64	611	0.2%
Other values (1317)	271730	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	90	< 0.1%
0.0553	1	< 0.1%
0.0556	1	< 0.1%
0.0561	1	< 0.1%
0.0562	1	< 0.1%
0.0564	1	< 0.1%
0.0565	2	< 0.1%
0.0566	1	< 0.1%
0.0567	1	< 0.1%
0.0569	1	< 0.1%

Value	Count	Frequency (%)
0.989	1	< 0.1%
0.988	3	< 0.1%
0.987	2	< 0.1%
0.986	2	< 0.1%
0.985	5	< 0.1%
0.984	2	< 0.1%
0.983	7	< 0.1%
0.982	1	< 0.1%
0.981	3	< 0.1%
0.98	8	< 0.1%

energy
Real number (ℝ)

HIGH CORRELATION

Distinct	2778
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.55686583

Minimum	0
Maximum	1
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0533
Q1	0.342
median	0.591
Q3	0.792
95-th percentile	0.951
Maximum	1
Range	1
Interquartile range (IQR)	0.45

Descriptive statistics

Standard deviation	0.27968133
Coefficient of variation (CV)	0.50224185
Kurtosis	-0.97720293
Mean	0.55686583
Median Absolute Deviation (MAD)	0.219
Skewness	-0.33499339
Sum	154774.18
Variance	0.078221644
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.727	438	0.2%
0.932	407	0.1%
0.634	403	0.1%
0.931	403	0.1%
0.726	397	0.1%
0.73	397	0.1%
0.869	396	0.1%
0.912	396	0.1%
0.665	396	0.1%
0.871	396	0.1%
Other values (2768)	273909	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1.99 × 10^-5	1	< 0.1%
2.01 × 10^-5	1	< 0.1%
2.02 × 10^-5	2	< 0.1%
2.03 × 10^-5	5	< 0.1%
5.62 × 10^-5	1	< 0.1%
7.15 × 10^-5	1	< 0.1%
8.6 × 10^-5	1	< 0.1%
0.000128	1	< 0.1%
0.000132	1	< 0.1%

Value	Count	Frequency (%)
1	145	0.1%
0.999	192	0.1%
0.998	191	0.1%
0.997	210	0.1%
0.996	219	0.1%
0.995	276	0.1%
0.994	236	0.1%
0.993	255	0.1%
0.992	202	0.1%
0.991	257	0.1%

loudness
Real number (ℝ)

HIGH CORRELATION

Distinct	32201
Distinct (%)	11.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-10.363654

Minimum	-60
Maximum	4.882
Zeros	0
Zeros (%)	0.0%
Negative	277624
Negative (%)	99.9%
Memory size	2.1 MiB

Quantile statistics

Minimum	-60
5-th percentile	-24.885
Q1	-12.747
median	-8.397
Q3	-5.842
95-th percentile	-3.421
Maximum	4.882
Range	64.882
Interquartile range (IQR)	6.905

Descriptive statistics

Standard deviation	6.6720495
Coefficient of variation (CV)	-0.64379315
Kurtosis	2.8428217
Mean	-10.363654
Median Absolute Deviation (MAD)	3.073
Skewness	-1.6053681
Sum	-2880453.3
Variance	44.516244
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.64	48	< 0.1%
-6.005	47	< 0.1%
-6.903	47	< 0.1%
-6.008	46	< 0.1%
-6.472	46	< 0.1%
-7.143	45	< 0.1%
-6.526	44	< 0.1%
-6.099	44	< 0.1%
-7.136	44	< 0.1%
-6.162	44	< 0.1%
Other values (32191)	277483	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-60	3	< 0.1%
-58.66	1	< 0.1%
-53.965	1	< 0.1%
-53.873	1	< 0.1%
-52.363	1	< 0.1%
-51.24	1	< 0.1%
-50.862	1	< 0.1%
-49.092	1	< 0.1%
-49.009	1	< 0.1%
-48.77	1	< 0.1%

Value	Count	Frequency (%)
4.882	1	< 0.1%
4.815	1	< 0.1%
4.584	1	< 0.1%
4.142	1	< 0.1%
3.795	1	< 0.1%
3.642	1	< 0.1%
2.994	1	< 0.1%
2.824	1	< 0.1%
2.744	1	< 0.1%
2.704	1	< 0.1%

speechiness
Real number (ℝ)

HIGH CORRELATION

Distinct	1640
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.087913272

Minimum	0
Maximum	0.965
Zeros	90
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0285
Q1	0.0359
median	0.0471
Q3	0.0822
95-th percentile	0.306
Maximum	0.965
Range	0.965
Interquartile range (IQR)	0.0463

Descriptive statistics

Standard deviation	0.11250014
Coefficient of variation (CV)	1.2796718
Kurtosis	22.055991
Mean	0.087913272
Median Absolute Deviation (MAD)	0.0146
Skewness	4.0972955
Sum	24434.439
Variance	0.01265628
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0337	854	0.3%
0.0362	841	0.3%
0.0345	841	0.3%
0.0336	829	0.3%
0.0323	829	0.3%
0.0324	828	0.3%
0.0334	826	0.3%
0.035	824	0.3%
0.0343	824	0.3%
0.0356	821	0.3%
Other values (1630)	269621	97.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	90	< 0.1%
0.022	1	< 0.1%
0.0221	2	< 0.1%
0.0222	2	< 0.1%
0.0223	6	< 0.1%
0.0224	5	< 0.1%
0.0225	3	< 0.1%
0.0226	6	< 0.1%
0.0227	10	< 0.1%
0.0228	9	< 0.1%

Value	Count	Frequency (%)
0.965	3	< 0.1%
0.964	1	< 0.1%
0.963	1	< 0.1%
0.962	2	< 0.1%
0.961	8	< 0.1%
0.96	7	< 0.1%
0.959	15	< 0.1%
0.958	14	< 0.1%
0.957	10	< 0.1%
0.956	20	< 0.1%

acousticness
Real number (ℝ)

HIGH CORRELATION

Distinct	5177
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.38658274

Minimum	0
Maximum	0.996
Zeros	51
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.00044985
Q1	0.0338
median	0.262
Q3	0.754
95-th percentile	0.985
Maximum	0.996
Range	0.996
Interquartile range (IQR)	0.7202

Descriptive statistics

Standard deviation	0.36450433
Coefficient of variation (CV)	0.94288827
Kurtosis	-1.3884633
Mean	0.38658274
Median Absolute Deviation (MAD)	0.25639
Skewness	0.44518238
Sum	107446.03
Variance	0.13286341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.995	2163	0.8%
0.994	1883	0.7%
0.993	1671	0.6%
0.992	1373	0.5%
0.991	1173	0.4%
0.99	991	0.4%
0.989	980	0.4%
0.988	931	0.3%
0.986	782	0.3%
0.987	778	0.3%
Other values (5167)	265213	95.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	51	< 0.1%
1 × 10^-6	2	< 0.1%
1.01 × 10^-6	4	< 0.1%
1.02 × 10^-6	2	< 0.1%
1.03 × 10^-6	1	< 0.1%
1.05 × 10^-6	3	< 0.1%
1.07 × 10^-6	1	< 0.1%
1.08 × 10^-6	1	< 0.1%
1.09 × 10^-6	1	< 0.1%
1.1 × 10^-6	3	< 0.1%

Value	Count	Frequency (%)
0.996	730	0.3%
0.995	2163	0.8%
0.994	1883	0.7%
0.993	1671	0.6%
0.992	1373	0.5%
0.991	1173	0.4%
0.99	991	0.4%
0.989	980	0.4%
0.988	931	0.3%
0.987	778	0.3%

instrumentalness
Real number (ℝ)

ZEROS

Distinct	5402
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.25504435

Minimum	0
Maximum	1
Zeros	71748
Zeros (%)	25.8%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.00109
Q3	0.645
95-th percentile	0.934
Maximum	1
Range	1
Interquartile range (IQR)	0.645

Descriptive statistics

Standard deviation	0.37374458
Coefficient of variation (CV)	1.4654102
Kurtosis	-0.88732226
Mean	0.25504435
Median Absolute Deviation (MAD)	0.00109
Skewness	0.97192936
Sum	70886.516
Variance	0.13968501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	71748	25.8%
0.899	493	0.2%
0.927	489	0.2%
0.925	481	0.2%
0.918	478	0.2%
0.922	473	0.2%
0.929	467	0.2%
0.932	465	0.2%
0.924	464	0.2%
0.923	463	0.2%
Other values (5392)	201917	72.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	71748	25.8%
1 × 10^-6	45	< 0.1%
1.01 × 10^-6	100	< 0.1%
1.02 × 10^-6	98	< 0.1%
1.03 × 10^-6	84	< 0.1%
1.04 × 10^-6	101	< 0.1%
1.05 × 10^-6	88	< 0.1%
1.06 × 10^-6	85	< 0.1%
1.07 × 10^-6	97	< 0.1%
1.08 × 10^-6	89	< 0.1%

Value	Count	Frequency (%)
1	2	< 0.1%
0.999	11	< 0.1%
0.998	13	< 0.1%
0.997	21	< 0.1%
0.996	18	< 0.1%
0.995	20	< 0.1%
0.994	37	< 0.1%
0.993	29	< 0.1%
0.992	27	< 0.1%
0.991	55	< 0.1%

liveness
Real number (ℝ)

Distinct	1766
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.18921667

Minimum	0
Maximum	1
Zeros	9
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0622
Q1	0.0962
median	0.121
Q3	0.227
95-th percentile	0.548
Maximum	1
Range	1
Interquartile range (IQR)	0.1308

Descriptive statistics

Standard deviation	0.16359636
Coefficient of variation (CV)	0.86459799
Kurtosis	6.3675305
Mean	0.18921667
Median Absolute Deviation (MAD)	0.0382
Skewness	2.3952294
Sum	52590.504
Variance	0.026763768
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.111	4198	1.5%
0.11	3943	1.4%
0.109	3690	1.3%
0.108	3512	1.3%
0.112	3449	1.2%
0.107	3349	1.2%
0.106	3155	1.1%
0.105	3133	1.1%
0.104	3030	1.1%
0.103	2928	1.1%
Other values (1756)	243551	87.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	< 0.1%
0.00785	1	< 0.1%
0.00918	1	< 0.1%
0.00967	1	< 0.1%
0.01	2	< 0.1%
0.0101	1	< 0.1%
0.0102	1	< 0.1%
0.0109	1	< 0.1%
0.0114	1	< 0.1%
0.012	1	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.998	1	< 0.1%
0.997	1	< 0.1%
0.996	2	< 0.1%
0.995	6	< 0.1%
0.994	7	< 0.1%
0.993	8	< 0.1%
0.992	11	< 0.1%
0.991	6	< 0.1%
0.99	17	< 0.1%

valence
Real number (ℝ)

HIGH CORRELATION

Distinct	1941
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.44960181

Minimum	0
Maximum	1
Zeros	135
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0434
Q1	0.22
median	0.434
Q3	0.665
95-th percentile	0.904
Maximum	1
Range	1
Interquartile range (IQR)	0.445

Descriptive statistics

Standard deviation	0.26747136
Coefficient of variation (CV)	0.59490721
Kurtosis	-1.0637139
Mean	0.44960181
Median Absolute Deviation (MAD)	0.222
Skewness	0.17384783
Sum	124961.43
Variance	0.071540929
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.961	645	0.2%
0.962	560	0.2%
0.963	494	0.2%
0.964	450	0.2%
0.96	404	0.1%
0.965	401	0.1%
0.196	399	0.1%
0.356	394	0.1%
0.392	394	0.1%
0.357	388	0.1%
Other values (1931)	273409	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	135	< 0.1%
1 × 10^-5	311	0.1%
2.08 × 10^-5	1	< 0.1%
3.64 × 10^-5	1	< 0.1%
0.000119	1	< 0.1%
0.000331	1	< 0.1%
0.000436	1	< 0.1%
0.000453	1	< 0.1%
0.000621	1	< 0.1%
0.000622	1	< 0.1%

Value	Count	Frequency (%)
1	4	< 0.1%
0.999	1	< 0.1%
0.998	1	< 0.1%
0.996	1	< 0.1%
0.995	2	< 0.1%
0.994	3	< 0.1%
0.993	3	< 0.1%
0.992	3	< 0.1%
0.991	3	< 0.1%
0.99	10	< 0.1%

tempo
Real number (ℝ)

Distinct	93680
Distinct (%)	33.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	119.196

Minimum	0
Maximum	244.947
Zeros	90
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	74.73155
Q1	95.07225
median	119.94
Q3	138.86975
95-th percentile	174.14515
Maximum	244.947
Range	244.947
Interquartile range (IQR)	43.7975

Descriptive statistics

Standard deviation	30.462256
Coefficient of variation (CV)	0.25556441
Kurtosis	-0.30242625
Mean	119.196
Median Absolute Deviation (MAD)	21.66
Skewness	0.31821845
Sum	33129099
Variance	927.94907
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120.008	100	< 0.1%
120.004	93	< 0.1%
0	90	< 0.1%
120.001	89	< 0.1%
120.007	86	< 0.1%
120.003	84	< 0.1%
120.013	84	< 0.1%
120.005	83	< 0.1%
120.009	81	< 0.1%
119.998	80	< 0.1%
Other values (93670)	277068	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	90	< 0.1%
30.186	1	< 0.1%
30.762	1	< 0.1%
31.084	1	< 0.1%
31.27	1	< 0.1%
31.47	1	< 0.1%
31.587	1	< 0.1%
31.967	2	< 0.1%
31.988	1	< 0.1%
32.074	1	< 0.1%

Value	Count	Frequency (%)
244.947	1	< 0.1%
241.808	1	< 0.1%
241.423	1	< 0.1%
240.118	1	< 0.1%
239.942	1	< 0.1%
236.059	1	< 0.1%
233.933	1	< 0.1%
232.5	1	< 0.1%
232.124	1	< 0.1%
232.031	1	< 0.1%

spec_rate
Real number (ℝ)

HIGH CORRELATION

Distinct	271727
Distinct (%)	97.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.7546539 × 10^-7

Minimum	0
Maximum	5.9718597 × 10^-5
Zeros	90
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	0
5-th percentile	9.560064 × 10^-8
Q1	1.5314613 × 10^-7
median	2.3454591 × 10^-7
Q3	4.449937 × 10^-7
95-th percentile	1.6326421 × 10^-6
Maximum	5.9718597 × 10^-5
Range	5.9718597 × 10^-5
Interquartile range (IQR)	2.9184757 × 10^-7

Descriptive statistics

Standard deviation	9.1902295 × 10^-7
Coefficient of variation (CV)	1.9328914
Kurtosis	555.71092
Mean	4.7546539 × 10^-7
Median Absolute Deviation (MAD)	1.0355598 × 10^-7
Skewness	16.050351
Sum	0.1321499
Variance	8.4460318 × 10^-13
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	90	< 0.1%
2.5 × 10^-7	20	< 0.1%
1.5 × 10^-7	17	< 0.1%
3 × 10^-7	14	< 0.1%
1.5625 × 10^-7	13	< 0.1%
5 × 10^-7	12	< 0.1%
1.875 × 10^-7	12	< 0.1%
2 × 10^-7	12	< 0.1%
1.666666667 × 10^-7	11	< 0.1%
2.666666667 × 10^-7	9	< 0.1%
Other values (271717)	277728	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	90	< 0.1%
9.464539229 × 10^-9	1	< 0.1%
1.017721648 × 10^-8	1	< 0.1%
1.021081294 × 10^-8	1	< 0.1%
1.065717172 × 10^-8	1	< 0.1%
1.084134625 × 10^-8	1	< 0.1%
1.196711281 × 10^-8	1	< 0.1%
1.23988488 × 10^-8	1	< 0.1%
1.249770707 × 10^-8	1	< 0.1%
1.306826401 × 10^-8	1	< 0.1%

Value	Count	Frequency (%)
5.97185968 × 10^-5	1	< 0.1%
5.555884267 × 10^-5	1	< 0.1%
5.342960289 × 10^-5	1	< 0.1%
5.270758123 × 10^-5	1	< 0.1%
5.138339921 × 10^-5	1	< 0.1%
4.948486628 × 10^-5	1	< 0.1%
4.941090985 × 10^-5	1	< 0.1%
4.9367221 × 10^-5	1	< 0.1%
4.099893162 × 10^-5	1	< 0.1%
4.040925517 × 10^-5	1	< 0.1%

labels
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

1	106429
0	82058
2	47065
3	42386

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	277938
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	1
3rd row	1
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
1	106429	38.3%
0	82058	29.5%
2	47065	16.9%
3	42386	15.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	106429	38.3%
0	82058	29.5%
2	47065	16.9%
3	42386	15.3%

Most occurring characters

Value	Count	Frequency (%)
1	106429	38.3%
0	82058	29.5%
2	47065	16.9%
3	42386	15.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	277938	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	106429	38.3%
0	82058	29.5%
2	47065	16.9%
3	42386	15.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	277938	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	106429	38.3%
0	82058	29.5%
2	47065	16.9%
3	42386	15.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	277938	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	106429	38.3%
0	82058	29.5%
2	47065	16.9%
3	42386	15.3%

uri
Text

UNIQUE

Distinct	277938
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	2.1 MiB

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	10005768
Distinct characters	63
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	277938 ?
Unique (%)	100.0%

Sample

1st row	spotify:track:3v6sBj3swihU8pXQQHhDZo
2nd row	spotify:track:7KCWmFdw0TzoJbKtqRRzJO
3rd row	spotify:track:2CY92qejUrhyPUASawNVRr
4th row	spotify:track:11BPfwVbB7vok7KfjBeW4k
5th row	spotify:track:3yUJKPsjvThlcQWTS9ttYx

Value	Count	Frequency (%)
spotify:track:3v6sbj3swihu8pxqqhhdzo	1	< 0.1%
spotify:track:03ibpduyi7g1voc9ejgrsy	1	< 0.1%
spotify:track:1i6guygzjf7xmukcwswj7k	1	< 0.1%
spotify:track:5x4b5yuoihfpbzmzsohg8m	1	< 0.1%
spotify:track:4ksq9el0qgtkkie5octkle	1	< 0.1%
spotify:track:2cy92qejurhypuasawnvrr	1	< 0.1%
spotify:track:11bpfwvbb7vok7kfjbew4k	1	< 0.1%
spotify:track:3yujkpsjvthlcqwts9ttyx	1	< 0.1%
spotify:track:41mocunogwtaybfusgnpz5	1	< 0.1%
spotify:track:5jp1cmcdxx4k2gwfsgt8lf	1	< 0.1%
Other values (277928)	277928	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
t	650439	6.5%
:	555876	5.6%
y	372979	3.7%
k	372517	3.7%
o	372430	3.7%
i	372386	3.7%
r	372374	3.7%
c	372230	3.7%
f	372134	3.7%
s	372129	3.7%
Other values (53)	5820274	58.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5786455	57.8%
Uppercase Letter	2443312	24.4%
Decimal Number	1220125	12.2%
Other Punctuation	555876	5.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	650439	11.2%
y	372979	6.4%
k	372517	6.4%
o	372430	6.4%
i	372386	6.4%
r	372374	6.4%
c	372230	6.4%
f	372134	6.4%
s	372129	6.4%
p	372051	6.4%
Other values (16)	1784786	30.8%

Uppercase Letter

Value	Count	Frequency (%)
K	94644	3.9%
A	94548	3.9%
D	94521	3.9%
H	94308	3.9%
Z	94297	3.9%
E	94296	3.9%
C	94288	3.9%
F	94251	3.9%
J	94235	3.9%
G	94233	3.9%
Other values (16)	1499691	61.4%

Decimal Number

Value	Count	Frequency (%)
1	130625	10.7%
3	129811	10.6%
0	129804	10.6%
6	129803	10.6%
5	129619	10.6%
2	129583	10.6%
4	129276	10.6%
7	122767	10.1%
9	94487	7.7%
8	94350	7.7%

Other Punctuation

Value	Count	Frequency (%)
:	555876	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8229767	82.3%
Common	1776001	17.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	650439	7.9%
y	372979	4.5%
k	372517	4.5%
o	372430	4.5%
i	372386	4.5%
r	372374	4.5%
c	372230	4.5%
f	372134	4.5%
s	372129	4.5%
p	372051	4.5%
Other values (42)	4228098	51.4%

Common

Value	Count	Frequency (%)
:	555876	31.3%
1	130625	7.4%
3	129811	7.3%
0	129804	7.3%
6	129803	7.3%
5	129619	7.3%
2	129583	7.3%
4	129276	7.3%
7	122767	6.9%
9	94487	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10005768	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	650439	6.5%
:	555876	5.6%
y	372979	3.7%
k	372517	3.7%
o	372430	3.7%
i	372386	3.7%
r	372374	3.7%
c	372230	3.7%
f	372134	3.7%
s	372129	3.7%
Other values (53)	5820274	58.2%

Auto

Heatmap
Table

	Unnamed: 0	Unnamed: 0.1	acousticness	danceability	duration (ms)	energy	instrumentalness	labels	liveness	loudness	spec_rate	speechiness	tempo	valence
Unnamed: 0	1.000	1.000	0.040	0.061	-0.056	-0.060	-0.034	0.156	-0.034	-0.004	0.012	-0.024	-0.029	-0.016
Unnamed: 0.1	1.000	1.000	0.040	0.061	-0.056	-0.060	-0.034	0.156	-0.034	-0.004	0.012	-0.024	-0.029	-0.016
acousticness	0.040	0.040	1.000	-0.236	-0.157	-0.761	0.219	0.528	-0.122	-0.649	-0.080	-0.200	-0.254	-0.222
danceability	0.061	0.061	-0.236	1.000	-0.078	0.232	-0.245	0.365	-0.072	0.276	0.241	0.249	0.023	0.506
duration (ms)	-0.056	-0.056	-0.157	-0.078	1.000	0.110	0.033	0.056	-0.032	0.060	-0.587	-0.114	0.038	-0.097
energy	-0.060	-0.060	-0.761	0.232	0.110	1.000	-0.278	0.599	0.210	0.813	0.175	0.287	0.268	0.370
instrumentalness	-0.034	-0.034	0.219	-0.245	0.033	-0.278	1.000	0.454	-0.131	-0.478	-0.173	-0.153	-0.085	-0.347
labels	0.156	0.156	0.528	0.365	0.056	0.599	0.454	1.000	-0.024	0.002	0.261	0.238	0.034	-0.119
liveness	-0.034	-0.034	-0.122	-0.072	-0.032	0.210	-0.131	-0.024	1.000	0.159	0.100	0.093	0.041	0.042
loudness	-0.004	-0.004	-0.649	0.276	0.060	0.813	-0.478	0.002	0.159	1.000	0.149	0.202	0.230	0.351
spec_rate	0.012	0.012	-0.080	0.241	-0.587	0.175	-0.173	0.261	0.100	0.149	1.000	0.827	0.053	0.166
speechiness	-0.024	-0.024	-0.200	0.249	-0.114	0.287	-0.153	0.238	0.093	0.202	0.827	1.000	0.101	0.140
tempo	-0.029	-0.029	-0.254	0.023	0.038	0.268	-0.085	0.034	0.041	0.230	0.053	0.101	1.000	0.136
valence	-0.016	-0.016	-0.222	0.506	-0.097	0.370	-0.347	-0.119	0.042	0.351	0.166	0.140	0.136	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Unnamed: 0.1	Unnamed: 0	duration (ms)	danceability	energy	loudness	speechiness	acousticness	instrumentalness	liveness	valence	tempo	spec_rate	labels	uri
0	0	0	195000.0	0.611	0.614	-8.815	0.0672	0.0169	0.000794	0.7530	0.520	128.050	3.446154e-07	2	spotify:track:3v6sBj3swihU8pXQQHhDZo
1	1	1	194641.0	0.638	0.781	-6.848	0.0285	0.0118	0.009530	0.3490	0.250	122.985	1.464234e-07	1	spotify:track:7KCWmFdw0TzoJbKtqRRzJO
2	2	2	217573.0	0.560	0.810	-8.029	0.0872	0.0071	0.000008	0.2410	0.247	170.044	4.007850e-07	1	spotify:track:2CY92qejUrhyPUASawNVRr
3	3	3	443478.0	0.525	0.699	-4.571	0.0353	0.0178	0.000088	0.0888	0.199	92.011	7.959809e-08	0	spotify:track:11BPfwVbB7vok7KfjBeW4k
4	4	4	225862.0	0.367	0.771	-5.863	0.1060	0.3650	0.000001	0.0965	0.163	115.917	4.693131e-07	1	spotify:track:3yUJKPsjvThlcQWTS9ttYx
5	5	5	166920.0	0.572	0.837	-7.876	0.0367	0.0197	0.000000	0.1630	0.627	100.343	2.198658e-07	1	spotify:track:41MOCUNOgWtaYBFUsGnpZ5
6	6	6	193133.0	0.725	0.687	-6.465	0.0596	0.6940	0.000369	0.2310	0.770	96.005	3.085956e-07	1	spotify:track:5JP1cMCDxX4k2gwfSgt8Lf
7	7	7	253000.0	0.675	0.547	-4.999	0.0481	0.1140	0.000080	0.0678	0.365	75.003	1.901186e-07	1	spotify:track:73xsMXuRNB3yqLeNc7NXBq
8	8	8	216187.0	0.516	0.692	-4.842	0.0279	0.0875	0.009300	0.0900	0.181	83.571	1.290549e-07	0	spotify:track:6TwrBbgTaB5gpl06YQoRKy
9	9	9	232333.0	0.548	0.509	-7.937	0.0288	0.2610	0.702000	0.0790	0.484	78.974	1.239600e-07	0	spotify:track:5SDEirHg6Y8fCYuKMnAaC5

	Unnamed: 0.1	Unnamed: 0	duration (ms)	danceability	energy	loudness	speechiness	acousticness	instrumentalness	liveness	valence	tempo	spec_rate	labels	uri
277928	277928	277928	369600.0	0.482	0.721	-6.839	0.0321	0.73100	0.000000	0.1890	0.557	95.263	8.685065e-08	0	spotify:track:3AhXZa8sUQht0UEdBJgpGc
277929	277929	277929	295893.0	0.671	0.373	-18.064	0.0323	0.25700	0.000080	0.0481	0.732	92.718	1.091611e-07	1	spotify:track:2374M0fQpWi3dLnB54qaLX
277930	277930	277930	187600.0	0.749	0.484	-9.944	0.0484	0.13000	0.137000	0.0486	0.939	167.084	2.579957e-07	1	spotify:track:7HX9f8AMBl0vQxAoAzLqhS
277931	277931	277931	236520.0	0.663	0.712	-7.268	0.0479	0.52400	0.000000	0.0804	0.527	113.439	2.025199e-07	1	spotify:track:2aSFLiDPreOVP6KHiWk4lF
277932	277932	277932	220867.0	0.746	0.790	-4.700	0.0257	0.04850	0.026100	0.0534	0.891	107.231	1.163596e-07	1	spotify:track:46RVKt5Edm1zl0rXhPJZxz
277933	277933	277933	276360.0	0.777	0.725	-9.012	0.0470	0.12600	0.010800	0.0917	0.851	128.349	1.700680e-07	1	spotify:track:6wLr2oR8eqUG5Beleh2Crm
277934	277934	277934	284773.0	0.543	0.482	-12.789	0.1940	0.08530	0.000092	0.1110	0.415	193.513	6.812444e-07	1	spotify:track:5mYtpXrZZ1bbGJYDGC8I0Y
277935	277935	277935	241307.0	0.527	0.942	-5.640	0.0366	0.01150	0.000000	0.1880	0.495	148.723	1.516740e-07	2	spotify:track:7FwBtcecmlpc1sLySPXeGE
277936	277936	277936	234333.0	0.768	0.829	-5.109	0.0313	0.09640	0.000029	0.0970	0.962	118.773	1.335706e-07	1	spotify:track:2olVm1lHicpveMAo4AUDRB
277937	277937	277937	241920.0	0.779	0.870	-13.141	0.0574	0.00644	0.010700	0.0399	0.555	102.689	2.372685e-07	1	spotify:track:2VNfJpwdEQBLyXajaa6LWT

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample